package DB;

import Model.Student;
import Model.Team;

import java.util.ArrayList;

public interface StudentDBIF {

    //Insert student
    public int insertStudent(Student student);

    //Find student by ID
    public Student findStudentByID (int id);

    //Find student by username, password
    public Student findStudent (String userName, String password);

    public Student findStudentByStudentNo(int studentNo);

    //Find all students
    public ArrayList<Student> getAllStudents(boolean retrieveAssociation);

    //Find all students by team
    public ArrayList<Student> getStudentsByTeam(Team team, boolean retrieveAssociation);

    //Update student
    public int updateStudent(Student student);

    //Delete student
    public int deleteStudent(int id);
}
